{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["SUMMARY","CHART DATA","TOTAL MARKET","ALDI","ASDA","BUDGENS","CO-OP","ICELAND","LIDL","M&S","MORRISONS","JS","TESCO","WAITROSE","CALLAGE"],"not_rendered":{"charts":72,"images":18,"macros":0,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SUMMARY","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,2,0,5]]}
[null,null,"       % British Facings"]
["Retailer","Product","2020-11-01","2021-01-01","v Last Time","v Year ago"]
["Aldi","Beef",1,1,0,0]
["Aldi","Lamb",1,1,0,0]
["Asda","Beef",0.65181458857348185,0.62515212981744417,-4.0904973934979522E-2,4.7798636825492922E-4]
["Asda","Lamb",0.62560000000000004,0.34686346863468637,-0.44555072149186964,-0.29474587797237484]
["Budgens","Beef",1,1,0,0]
["Budgens","Lamb",1,1,0,0]
["Co-op","Beef",1,1,0,0]
["Co-op","Lamb",1,1,0,0]
["Iceland","Beef",1,0.69186046511627908,-0.30813953488372092,-0.28481839561013844]
["Iceland","Lamb",0.04,0.14285714285714285,2.5714285714285712,-0.11428571428571431]
["Lidl","Beef",1,1,0,0]
["Lidl","Lamb",1,0.32773109243697479,-0.67226890756302526,-0.39053516143299422]
["M&S","Beef",1,1,0,0]
["M&S","Lamb",1,1,0,0]
["Morrisons","Beef",0.99676724137931039,0.99761478831246275,8.5029573401664341E-4,-2.3852116875372475E-3]
["Morrisons","Lamb",1,1,0,0]
["Sainsburys","Beef",0.82264296754250388,0.91976598412035104,0.11806217327546663,2.4622934578253045E-2]
["Sainsburys","Lamb",0.99591280653950953,0.89418777943368111,-0.10214250327726138,-9.7203914627125826E-2]
["Tesco","Beef",0.76714868372265477,0.7218463987266216,-5.9052809393089156E-2,4.1387150881609457E-2]
["Tesco","Lamb",0.79083094555873923,0.84982332155477036,7.4595431965995884E-2,-0.12184923439340399]
["Waitrose","Beef",1,1,0,0]
["Waitrose","Lamb",1,1,0,4.7945205479451997E-2]
["Total","Beef",0.8591506952273581,0.85022801824145933,-1.0385462102824174E-2,2.0171246451070653E-2]
["Total","Lamb",0.88493073225897656,0.80624601657106432,-8.8916242616020963E-2,-7.2672309376474203E-2]

{"sheet":"CHART DATA","index":1,"n_rows":29,"n_cols":41,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Individual Phase Graph Data"]
[]
["Report 1",{"$nulls":13},"Report 2",{"$nulls":13},"Report 3"]
["Columns Identified With QSM Vs Total",{"$nulls":13},"Total All British, vs Total ",{"$nulls":13},"Total Red Tractor Columns vs Total Columns"]
["Retailer",null,"2018-08-01","2018-11-01","2019-01-01","2019-06-01","2019-08-01","2019-11-01","2020-01-01","2020-06-01","2020-08-01","2020-11-01","2021-01-01",null,"Retailer",null,"2018-08-01","2018-11-01","2019-01-01","2019-06-01","2019-08-01","2019-11-01","2020-01-01","2020-06-01","2020-08-01","2020-11-01","2021-01-01",null,"Retailer",null,"2018-08-01","2018-11-01","2019-01-01","2019-06-01","2019-08-01","2019-11-01","2020-01-01","2020-06-01","2020-08-01","2020-11-01","2021-01-01"]
["Aldi","Beef",0,0,0,0,0,0,0,4.2674253200568994E-3,0,0,0,null,"Aldi","Beef",1,0.98738170347003151,1,1,1,1,1,1,1,1,1,null,"Aldi","Beef",1,0.98738170347003151,1,0.99679487179487181,1,1,0.99846860643185298,0.98862019914651489,0.99856115107913668,0.99860917941585536,1]
["Aldi","Lamb",0,0,0,0,0,0,0,0,0,0,0,null,"Aldi","Lamb",1,1,1,1,1,1,1,1,1,1,1,null,"Aldi","Lamb",1,1,1,1,1,1,1,1,1,1,1]
["Asda","Beef",0,2.16998191681736E-3,0,0,4.2583392476933995E-3,7.2692793931731989E-3,1.7584994138335288E-3,4.5936395759717313E-3,2.0359687818120122E-3,0,0,null,"Asda","Beef",0.53856041131105403,0.54828209764918623,0.54648956356736245,0.67256932843301032,0.66713981547196588,0.62420986093552466,0.62485345838218054,0.66925795053003534,0.73227010519172042,0.65181458857348185,0.62515212981744417,null,"Asda","Beef",0.45501285347043702,0.43435804701627484,0.48703352308665404,0.5696625459405279,0.59652235628105044,0.55372945638432369,0.53311840562719814,0.51554770318021204,0.4794706481167289,0.53503413582464965,0.4997971602434077]
["Asda","Lamb",7.2026800670016752E-2,5.4317548746518104E-2,3.1944444444444442E-2,4.1322314049586778E-2,6.7796610169491525E-2,5.7915057915057917E-2,3.7147102526002972E-2,1.4285714285714285E-2,1.639344262295082E-3,5.28E-2,7.3800738007380072E-3,null,"Asda","Lamb",0.52428810720268004,0.57103064066852371,0.4597222222222222,0.35537190082644626,0.47303543913713403,0.59073359073359077,0.49182763744427932,0.41587301587301589,0.45409836065573772,0.62560000000000004,0.34686346863468637,null,"Asda","Lamb",0.47571189279731996,0.4763231197771588,0.40555555555555556,0.228099173553719,0.43759630200308164,0.4646074646074646,0.35066864784546803,0.26666666666666666,0.25901639344262295,0.35520000000000002,0.26383763837638374]
["Budgens","Beef",0,0,0,0,0,0,0,0,0,0,0,null,"Budgens","Beef",1,1,1,0.91428571428571426,1,1,1,0.98148148148148151,1,1,1,null,"Budgens","Beef",0.6741573033707865,0.74683544303797467,0.75,0.62857142857142856,0.48571428571428571,0.40322580645161288,0.49230769230769234,0.16666666666666666,0.23809523809523808,9.0909090909090912E-2,0.24444444444444444]
["Budgens","Lamb",0,0,0,0,0,0,0,0,0,0,0,null,"Budgens","Lamb",1,1,1,0.82352941176470584,0.84,1,1,1,0.88888888888888884,1,1,null,"Budgens","Lamb",0.75757575757575757,1,0.88888888888888884,0.47058823529411764,0.52,0.77777777777777779,0.33333333333333331,0.23076923076923078,0.44444444444444442,0,0]
["Co-op","Beef",0,0,0,0,0,0,0,0,0,0,0,null,"Co-op","Beef",1,1,1,1,1,1,1,1,1,1,1,null,"Co-op","Beef",1,1,1,0.98982188295165396,1,1,1,1,1,1,1]
["Co-op","Lamb",0,0,0,0,0,0,0,0,0,0,0,null,"Co-op","Lamb",1,1,1,1,1,1,1,1,1,1,1,null,"Co-op","Lamb",1,1,1,1,1,1,1,1,1,1,1]
["Iceland","Beef",0,0,0,0,0,0,0,0,0,0,0,null,"Iceland","Beef",0.91752577319587625,0.9731182795698925,0.95477386934673369,0.97156398104265407,0.95833333333333337,0.97309417040358748,0.96739130434782605,0.75724637681159424,1,1,0.69186046511627908,null,"Iceland","Beef",5.1546391752577317E-2,4.8387096774193547E-2,0,0,0,0,0,0,0,0,0]
["Iceland","Lamb",0,0,0,0,0,0,0,0,0,0,0,null,"Iceland","Lamb",0.30434782608695654,6.25E-2,0.5,0.15789473684210525,0.11538461538461539,0,0.16129032258064516,0.52777777777777779,0.1388888888888889,0.04,0.14285714285714285,null,"Iceland","Lamb",0,0,0,0,0,0,0,0,0,0,0]
["Lidl","Beef",0,0,0,0,0,0,2.828854314002829E-3,0,0,0,0,null,"Lidl","Beef",0.99402092675635279,1,1,1,0.98895027624309395,1,1,0.97170971709717102,0.99734042553191493,1,1,null,"Lidl","Beef",0.95216741405082217,0.97768479776847983,0.98124999999999996,0.98593350383631717,0.96961325966850831,0.98753462603878117,0.98019801980198018,0.92250922509225097,0.94946808510638303,0.98142857142857143,0.99628712871287128]
["Lidl","Lamb",0,0,0,0,0,0,0,0,0,0,0,null,"Lidl","Lamb",1,1,0.76041666666666663,0.1744186046511628,1,1,0.53773584905660377,0.55294117647058827,1,1,0.32773109243697479,null,"Lidl","Lamb",1,1,0.76041666666666663,0.1744186046511628,1,1,0.53773584905660377,0.55294117647058827,1,1,0.29411764705882354]
["M&S","Beef",0,0,0,0,0,0,0,1.5625E-2,0,0,0,null,"M&S","Beef",1,1,0.99826689774696709,0.99854227405247797,1,1,1,0.99843749999999998,1,1,1,null,"M&S","Beef",0,0,0,0,0,0,0,3.1250000000000002E-3,0,0,0]
["M&S","Lamb",0,0,0,0,0,0,0,0,0,0,0,null,"M&S","Lamb",1,1,0.96268656716417911,0.98518518518518516,0.87804878048780488,0.98076923076923073,1,0.83448275862068966,0.9147286821705426,1,1,null,"M&S","Lamb",0,0,0,0,0,0,0,0,0,0,0]
["Morrisons","Beef",0,0,0,2.1168501270110076E-3,0,1.8544274455261937E-3,0,1.2380416432189083E-2,3.1007751937984496E-3,2.6939655172413795E-3,0,null,"Morrisons","Beef",1,1,1,1,1,1,1,1,1,0.99676724137931039,0.99761478831246275,null,"Morrisons","Beef",0.95736040609137052,0.92753623188405798,0.98353360035603021,0.97036409822184588,0.97377777777777774,0.98423736671302731,0.97423887587822011,0.98930782217220037,0.97364341085271322,0.97036637931034486,0.9952295766249255]
["Morrisons","Lamb",0,0,0,0,0,0,0,0,0,0,0,null,"Morrisons","Lamb",1,1,1,0.9966666666666667,1,1,1,1,1,1,1,null,"Morrisons","Lamb",1,0.92459016393442628,0.94247787610619471,0.97,1,1,0.9771986970684039,0.99613152804642169,0.98163265306122449,0.98223801065719363,0.97478991596638653]
["Sainsburys","Beef",0,0,0,0,0,0,0,0,0,1.1591962905718701E-3,0,null,"Sainsburys","Beef",0.94393741851368973,0.92733812949640293,0.88298228017385494,0.87433264887063655,0.88677685950413221,0.84097035040431267,0.89766288951841355,0.88605955977557183,0.87815884476534301,0.82264296754250388,0.91976598412035104,null,"Sainsburys","Beef",0,0,0,0,0,0,0,1.1652999568407424E-2,0,0,0]
["Sainsburys","Lamb",2.6737967914438501E-3,0,0,0,0,3.2085561497326204E-3,0,2.4906600249066001E-2,9.9750623441396506E-3,0,0,null,"Sainsburys","Lamb",0.94919786096256686,0.97448359659781292,0.97869674185463662,0.52721088435374153,0.96361355081555833,0.96256684491978606,0.99046483909415972,0.82689912826899126,0.97007481296758102,0.99591280653950953,0.89418777943368111,null,"Sainsburys","Lamb",2.6737967914438501E-3,0,0,0,0,0,0,2.4906600249066001E-2,2.4937655860349127E-3,0,1.4903129657228018E-3]
["Tesco","Beef",0,0,0,0,0,0,0,0,0,0,1.5917230401910067E-3,null,"Tesco","Beef",0.64910503208375547,0.56301856973528253,0.65791420118343191,0.63579168123033902,0.70476190476190481,0.73244147157190631,0.69315854158131918,0.76098801307664365,0.76214574898785425,0.76714868372265477,0.7218463987266216,null,"Tesco","Beef",0.61127997298210068,0.52469379691821416,0.55880177514792895,0.59769311429570082,0.63589743589743586,0.70308435525826829,0.64563703400245798,0.6905194333454413,0.69197031039136303,0.71486837226548017,0.62713887783525668]
["Tesco","Lamb",0,0,0,0,0,0,0,4.8231511254019296E-3,0,0,0,null,"Tesco","Lamb",0.69188445667125176,0.69485903814262018,0.85993485342019549,0.82780410742496047,0.77744807121661719,0.88265306122448983,0.967741935483871,0.83279742765273312,0.84393939393939399,0.79083094555873923,0.84982332155477036,null,"Tesco","Lamb",0.55433287482806048,0.56550580431177444,0.71172638436482083,0.71721958925750395,0.68545994065281901,0.80612244897959184,0.86789554531490021,0.752411575562701,0.77272727272727271,0.72349570200573066,0.78268551236749118]
["Waitrose","Beef",0,0,0,0,0,0,0,0,0,0,0,null,"Waitrose","Beef",1,1,1,1,1,1,1,1,1,1,1,null,"Waitrose","Beef",0.97458563535911602,0.99024390243902438,0.98137369033760191,0.98957126303592124,0.96837513631406757,0.96770025839793283,0.9748148148148148,0.95539906103286387,0.95668789808917198,0.95739644970414206,0.99334221038615178]
["Waitrose","Lamb",5.9659090909090912E-2,4.788732394366197E-2,0,6.2841530054644809E-2,5.3050397877984087E-2,7.8549848942598186E-2,7.5163398692810454E-2,0,5.181347150259067E-2,5.2256532066508314E-2,0,null,"Waitrose","Lamb",1,1,0.55922865013774103,0.86885245901639341,1,1,0.95424836601307195,0.95967741935483875,1,1,1,null,"Waitrose","Lamb",0.92613636363636365,0.92676056338028168,0.48209366391184572,0.76502732240437155,0.91777188328912462,0.93051359516616317,0.90196078431372551,0.86021505376344087,0.88082901554404147,0.88836104513064129,0.96073298429319376]
["Total","Beef",0,4.4137119317345886E-4,0,3.5014005602240897E-4,8.7540122556171583E-4,1.9018102416003381E-3,5.734355960146226E-4,3.5930833146193579E-3,8.9652596189764662E-4,2.2547914317925591E-3,3.2002560204816386E-4,null,"Total","Beef",0.80953763518908328,0.81094600559070174,0.81371608659906824,0.83606442577030815,0.85154654216515901,0.83186588715925902,0.83341695935775217,0.85350699902687321,0.86806126260739636,0.8591506952273581,0.85022801824145933,null,"Total","Beef",0.5594106118893809,0.52243636898631751,0.54302548643463966,0.58732492997198882,0.60227604318646044,0.57786856378108054,0.56590925381693069,0.58080694662774157,0.59073589839372431,0.59917324314167608,0.57260580846467712]
["Total","Lamb",1.9486271036315322E-2,1.5444015444015444E-2,6.2875888463641335E-3,1.3521126760563381E-2,1.8161180476730987E-2,2.0357634112792296E-2,1.3624751632131706E-2,9.3814130753444736E-3,8.4671532846715327E-3,1.5549901046084252E-2,1.2746972594008922E-3,null,"Total","Lamb",0.83407144966046654,0.85438499724214012,0.81109896118097324,0.70197183098591553,0.84023836549375708,0.87592847317744149,0.86942946352540451,0.79331574318381703,0.85313868613138688,0.88493073225897656,0.80624601657106432,null,"Total","Lamb",0.53587245349867141,0.53778268063982348,0.50492072170585023,0.47436619718309858,0.55561861520998868,0.55405777166437409,0.55066704513198983,0.50688947522720607,0.52496350364963507,0.56036188860616343,0.53346080305927346]

{"sheet":"TOTAL MARKET","index":2,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in ",{"$nulls":8},"the TOTAL GB MARKET"]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"ALDI","index":3,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"ASDA","index":4,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"BUDGENS","index":5,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"CO-OP","index":6,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"ICELAND","index":7,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"LIDL","index":8,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"M&S","index":9,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"MORRISONS","index":10,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"JS","index":11,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"TESCO","index":12,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"WAITROSE","index":13,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[" Looking at the % British, Red Tractor and the % QSM sold in "]
{"$rows_empty":60}
["Beef & Lamb Country Of Origin Survey",null,null,null,"Phase",30,"Date",{"$f":"'CHART DATA'!$M$5","v":"2021-01-01"}]

{"sheet":"CALLAGE","index":14,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["AHDB Beef & Lamb Country Of Origin Survey - Summary Of Callage"]
[]
["Number Of Stores Per Retailer"]
["Fieldwork Dates","2017-06-01","2017-08-01","2017-11-01","2018-01-01","2018-06-01","2018-08-01","2018-11-01","2019-01-01","2019-06-01","2019-08-01","2019-11-01","2020-01-01","2020-06-01","2020-08-01","2020-11-01","2021-01-01"]
["Aldi",14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14]
["Asda",20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
["Budgens",10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10]
["Coop",14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14]
["Lidl",10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10]
["M&S",10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10]
["Morrisons",18,18,18,18,18,18,18,18,18,18,18,18,18,18,18,18]
["Sainsburys",20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
["Tesco",20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
["Waitrose",14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14]
["Iceland",0,0,0,0,0,0,0,0,10,10,10,10,10,10,10,10]
["TOTAL",150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150]